home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The Arsenal Files 6
/
The Arsenal Files 6 (Arsenal Computer).ISO
/
prg_basi
/
ddfedit.zip
/
DDFNWFLD.FRM
< prev
next >
Wrap
Text File
|
1996-02-05
|
13KB
|
424 lines
VERSION 2.00
Begin Form FormNewField
BackColor = &H00C0C0C0&
BorderStyle = 1 'Fixed Single
Caption = "Add New Field"
ClientHeight = 1680
ClientLeft = 2175
ClientTop = 3420
ClientWidth = 3945
ControlBox = 0 'False
Height = 2085
Left = 2115
LinkTopic = "Form3"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 1680
ScaleWidth = 3945
Top = 3075
Width = 4065
Begin TextBox NewFieldDataType
Height = 285
Left = 3720
TabIndex = 23
Top = 960
Visible = 0 'False
Width = 180
End
Begin TextBox FieldIdx
Height = 285
Left = 3360
TabIndex = 22
Top = 960
Visible = 0 'False
Width = 180
End
Begin TextBox XPath
Height = 285
Left = 2040
TabIndex = 21
Top = 960
Visible = 0 'False
Width = 180
End
Begin TextBox XFDFlags
Height = 285
Left = 3000
TabIndex = 20
Top = 960
Visible = 0 'False
Width = 180
End
Begin TextBox XFDLocation
Height = 285
Left = 2760
TabIndex = 19
Top = 960
Visible = 0 'False
Width = 180
End
Begin TextBox XFDName
Height = 285
Left = 2520
TabIndex = 18
Top = 960
Visible = 0 'False
Width = 180
End
Begin TextBox XFDid
Height = 285
Left = 2280
TabIndex = 17
Top = 960
Visible = 0 'False
Width = 180
End
Begin SSPanel Panel3D5
AutoSize = 3 'AutoSize Child To Panel
BevelInner = 1 'Inset
BevelOuter = 0 'None
BorderWidth = 1
Caption = "Panel3D1"
Height = 285
Left = 1035
TabIndex = 16
Top = 1350
Width = 870
Begin TextBox NewFieldDec
BorderStyle = 0 'None
Height = 225
Left = 30
MaxLength = 20
TabIndex = 9
Top = 30
Width = 810
End
End
Begin SSPanel Panel3D4
AutoSize = 3 'AutoSize Child To Panel
BevelInner = 1 'Inset
BevelOuter = 0 'None
BorderWidth = 1
Caption = "Panel3D1"
Height = 285
Left = 1035
TabIndex = 15
Top = 990
Width = 870
Begin TextBox NewFieldSize
BorderStyle = 0 'None
Height = 225
Left = 30
MaxLength = 20
TabIndex = 7
Top = 30
Width = 810
End
End
Begin SSPanel Panel3D3
AutoSize = 3 'AutoSize Child To Panel
BevelInner = 1 'Inset
BevelOuter = 0 'None
BorderWidth = 1
Caption = "Panel3D1"
Height = 285
Left = 1035
TabIndex = 14
Top = 990
Visible = 0 'False
Width = 870
Begin TextBox NewFieldOffset
BackColor = &H00C0C0C0&
BorderStyle = 0 'None
Enabled = 0 'False
Height = 225
Left = 30
MaxLength = 20
MultiLine = -1 'True
TabIndex = 5
Top = 30
Visible = 0 'False
Width = 810
End
End
Begin CommandButton ButOk
Caption = "OK"
Default = -1 'True
Height = 330
Left = 2655
TabIndex = 10
Top = 1320
Width = 1230
End
Begin CommandButton butcan
Cancel = -1 'True
Caption = "Cancel"
Height = 330
Left = 2640
TabIndex = 11
Top = 960
Width = 1230
End
Begin SSPanel Panel3D2
AutoSize = 3 'AutoSize Child To Panel
BevelInner = 1 'Inset
BevelOuter = 0 'None
BorderWidth = 1
Caption = "Panel3D1"
Height = 375
Left = 1035
TabIndex = 13
Top = 495
Width = 2805
Begin ComboBox ComboDataType
Height = 315
Left = 30
Style = 2 'Dropdown List
TabIndex = 3
Top = 30
Width = 2745
End
End
Begin SSPanel Panel3D1
AutoSize = 3 'AutoSize Child To Panel
BevelInner = 1 'Inset
BevelOuter = 0 'None
BorderWidth = 1
Caption = "Panel3D1"
Height = 285
Left = 1035
TabIndex = 12
Top = 90
Width = 2805
Begin TextBox NewFieldName
BorderStyle = 0 'None
Height = 225
Left = 30
MaxLength = 20
TabIndex = 1
Top = 30
Width = 2745
End
End
Begin Label Label5
BackColor = &H00C0C0C0&
Caption = "&Decimal"
ForeColor = &H00FF0000&
Height = 195
Left = 135
TabIndex = 8
Top = 1395
Width = 825
End
Begin Label Label4
BackColor = &H00C0C0C0&
Caption = "&Size"
ForeColor = &H00FF0000&
Height = 195
Left = 135
TabIndex = 6
Top = 1035
Width = 825
End
Begin Label Label3
BackColor = &H00C0C0C0&
Caption = "&Offset"
ForeColor = &H00FF0000&
Height = 195
Left = 135
TabIndex = 4
Top = 1035
Visible = 0 'False
Width = 825
End
Begin Label Label2
BackColor = &H00C0C0C0&
Caption = "&Type"
ForeColor = &H00FF0000&
Height = 285
Left = 135
TabIndex = 2
Top = 540
Width = 825
End
Begin Label Label1
BackColor = &H00C0C0C0&
Caption = "&Name"
ForeColor = &H00FF0000&
Height = 195
Left = 135
TabIndex = 0
Top = 135
Width = 825
End
End
Option Explicit
Dim inited As Integer
Sub butcan_Click ()
Unload Me
End Sub
Sub ButOk_Click ()
Dim i As Integer
Dim FormID As Integer
Dim fidx As Integer
NewFieldName.Text = Trim(NewFieldName.Text)
If NewFieldName.Text = "" Then
MsgBox "No Field Name Specified", , "Error"
Exit Sub
End If
If Val(NewFieldSize.Text) = 0 Then
MsgBox "No Size Specified", , "Error"
Exit Sub
End If
' look for the parent form
FormID = -1
For i = 0 To forms.Count - 1
If forms(i).Tag = "D" & Trim(xfdid.Text) Then
FormID = i
Exit For
End If
Next i
If FormID = -1 Then
MsgBox "ERROR : Can't find parent form"
Exit Sub
End If
fidx = Val(FieldIdx.Text)
If fidx = -1 Then
forms(FormID).Llist.AddItem NewFieldName & Chr(9) & Format(ComboDataType.ItemData(ComboDataType.ListIndex), "0") & Chr(9) & Format(Val(NewFieldOffset.Text), "0") & Chr(9) & Format(Val(NewFieldSize.Text), "0") & Chr(9) & Format(Val(NewFieldDec), "0") & Chr(9) & ""
Else
forms(FormID).Llist.RemoveItem fidx
forms(FormID).Llist.AddItem NewFieldName & Chr(9) & Format(ComboDataType.ItemData(ComboDataType.ListIndex), "0") & Chr(9) & Format(Val(NewFieldOffset.Text), "0") & Chr(9) & Format(Val(NewFieldSize.Text), "0") & Chr(9) & Format(Val(NewFieldDec), "0") & Chr(9) & "", fidx
End If
Curr_File_changed = True
Unload Me
End Sub
Sub Form_Activate ()
Dim i As Integer
If inited Then Exit Sub
If Val(FieldIdx.Text) = -1 Then Exit Sub' its a new field
For i = 0 To ComboDataType.ListCount - 1
If ComboDataType.ItemData(i) = Val(NewFieldDataType.Text) Then
ComboDataType.ListIndex = i
Exit For
End If
Next i
inited = True
End Sub
Sub Form_Load ()
inited = False
left = (screen.Width - Width) / 2
top = (screen.Height - Height) / 2
ComboDataType.Clear
' 0 String
' 1 Integer
' 2 Float
' 3 Date
' 4 Time
' 5 Decimal
' 6 Money
' 7 Logical
' 8 Numeric
' 9 Bfloat
' 10 Lstring
' 11 Zstring
' 14 Unsigned
' 15 AutoInc
ComboDataType.AddItem "String": ComboDataType.ItemData(ComboDataType.NewIndex) = 0
ComboDataType.AddItem "Integer": ComboDataType.ItemData(ComboDataType.NewIndex) = 1
ComboDataType.AddItem "Float": ComboDataType.ItemData(ComboDataType.NewIndex) = 2
ComboDataType.AddItem "Date": ComboDataType.ItemData(ComboDataType.NewIndex) = 3
ComboDataType.AddItem "Time": ComboDataType.ItemData(ComboDataType.NewIndex) = 4
ComboDataType.AddItem "Decimal": ComboDataType.ItemData(ComboDataType.NewIndex) = 5
ComboDataType.AddItem "Money": ComboDataType.ItemData(ComboDataType.NewIndex) = 6
ComboDataType.AddItem "Logical": ComboDataType.ItemData(ComboDataType.NewIndex) = 7
ComboDataType.AddItem "Numeric": ComboDataType.ItemData(ComboDataType.NewIndex) = 8
ComboDataType.AddItem "BFloat": ComboDataType.ItemData(ComboDataType.NewIndex) = 9
ComboDataType.AddItem "lstring": ComboDataType.ItemData(ComboDataType.NewIndex) = 10
ComboDataType.AddItem "zstring": ComboDataType.ItemData(ComboDataType.NewIndex) = 11
ComboDataType.AddItem "Note": ComboDataType.ItemData(ComboDataType.NewIndex) = 12
ComboDataType.AddItem "lvar": ComboDataType.ItemData(ComboDataType.NewIndex) = 13
ComboDataType.AddItem "Unsigned": ComboDataType.ItemData(ComboDataType.NewIndex) = 14
ComboDataType.AddItem "AutoInc": ComboDataType.ItemData(ComboDataType.NewIndex) = 15
ComboDataType.ListIndex = 0
End Sub
Sub Old_ButOK_click ()
Dim stat As Integer
Dim KeyNum As Integer
Dim PosBlk As PosBlkDef
Dim Keybuf As KeyBufDef
Dim KeyBufLen As Integer
Dim BufLen As Integer
Dim FileFullPath As String
Dim XDField As XDField_def
NewFieldName.Text = Trim(NewFieldName.Text)
If NewFieldName.Text = "" Then
MsgBox "No Field Name Specified", , "Error"
Exit Sub
End If
If Val(NewFieldSize.Text) = 0 Then
MsgBox "No Size Specified", , "Error"
Exit Sub
End If
' Curr_XFDid
' ************************************************************************************
' Now we add records to the FIELD.DDF file
' ************************************************************************************
FileFullPath = XPath.Text & "FIELD.DDF"
Keybuf.kb = FileFullPath
KeyBufLen = Len(Keybuf)
BufLen = 0
status "Adding Fields to file " & FileFullPath
stat = btrcall(B_OPEN, PosBlk, XDField, BufLen, Keybuf, KeyBufLen, 0)
If stat <> 0 Then
MsgBox "Btrieve Error Opening file " & FileFullPath & Chr(10) & stat & " " & BtErr(stat)
Exit Sub
End If
' Records for FILE.DDF
If AddRecordToFieldDDF(PosBlk, (Val(xfdid.Text)), (NewFieldName.Text), (ComboDataType.ItemData(ComboDataType.ListIndex)), (Val(NewFieldOffset.Text)), (Val(NewFieldSize.Text)), (Val(NewFieldDec.Text)), 0) = False Then
End If
stat = btrcall(B_CLOSE, PosBlk, XDField, BufLen, Keybuf, KeyBufLen, 0)
Curr_File_changed = True
Unload Me
End Sub